select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and a.houseType = 3 and c.enDistrictName = 'Xuhui' and (b.cnpropertyname like '%Old house in Wukang Road%' or b.enpropertyname like '%Old house in Wukang Road%') order by updateTime Desc, a.dftpic desc
located in the heart of FFC Area, this recently renovated three bedroom paradise exquisite decoration, nostalgic furnishings, all of which let you enjoy the bus...
Delicated decoration,the property comprises a brigh and sunny livingroom and well equipped contemporary kitchen, north-south transparent, good ventilation, good...